

clear all
set more off
capture log close
set mat 5000

cd "C:\Users\rujia\Dropbox\coalmine\restat"

use  CoalMine.dta, clear
drop if native==.
drop if leader_id==.


gen ln_output = log(prod0)

gen prod0_normalized=prod0/10000
label var prod0_normalized "Output"


label var ln_output "ln Output"


bysort prov_id: egen pre_deathrate=mean(deathrate) if year<1998
bysort prov_id: egen m_pre_deathrate=mean(pre_deathrate) 
gen pre_year=m_pre_deathrate*year
gen decentralized=(year>=1998 & year<=2000)

tabu prov_id, gen (pdummy)
forvalues i=1(1)22{
gen prov_year`i'=pdummy`i'*year
}

gen period=1 if year<1998
replace period=2 if year>=1998 & year<=2000
replace period=3 if year>2000 & year<=2005

egen clusterg=group(prov_id period)

gen decentralized_native=decentralized*native

gen ln_wage=log(indwage)
gen tenure=year-startyear+1
gen ln_gdpper=log(gdpper)
gen ln_electricity=log(eleconsum)
gen ln_disbeijing=log(1+dis_beijing)




merge 1:1 prov_id year  using data/TrafficPanel.dta

drop _m

merge 1:1 prov_id year using data/LocalCoalmine.dta

drop _m
merge 1:1 prov_id year using data/Population.dta


gen trafficper=mortality/popu

local controls " ln_wage tenure age ln_gdpper ln_electricity gov_native s_native ln_disbeijing"


foreach var in ln_wage tenure age ln_gdpper ln_electricity gov_native s_native ln_disbeijing {
gen decentralized_`var'=decentralized*`var'
}



gen ln_death=log(death)

gen native_decentralized=native*decentralized
label var native_decentralized "Decentralization * Native"
label var native "Native"

label var ln_death "ln Death"
label var ln_output "ln Output"




#delimit ;

eststo clear;


eststo: xi:areg ln_death native_decentralized native i.prov_id i.year prov_year*, absorb(prov_id) cluster (clusterg);
estadd local pfe "Y";
estadd local yfe "Y";
estadd local ptrend "Y";
estadd scalar nobs=e(N);
estadd scalar rsq=e(r2);


eststo: xi:areg ln_death native_decentralized native i.prov_id i.year `controls'    prov_year*, absorb(leader_id) cluster (clusterg);
estadd local pfe "Y";
estadd local yfe "Y";
estadd local ptrend "Y";

estadd local rfe "Y";
estadd local controls "Y";
estadd scalar nobs=e(N);
estadd scalar rsq=e(r2);
eststo: xi:areg ln_death native_decentralized native i.prov_id i.year `controls' decentralized_* prov_year*, absorb(leader_id) cluster (clusterg);
estadd local pfe "Y";
estadd local yfe "Y";
estadd local ptrend "Y";
estadd local rfe "Y";
estadd local controls "Y";
estadd local controls_d "Y";

estadd scalar nobs=e(N);
estadd scalar rsq=e(r2);


eststo: xi:areg ln_output native_decentralized native i.prov_id i.year prov_year*, absorb(prov_id) cluster (clusterg);
estadd local pfe "Y";
estadd local yfe "Y";
estadd local ptrend "Y";
estadd scalar nobs=e(N);
estadd scalar rsq=e(r2);



eststo: xi:areg ln_output native_decentralized native i.prov_id i.year `controls'   prov_year* , absorb(leader_id) cluster (clusterg);
estadd local pfe "Y";
estadd local yfe "Y";
estadd local ptrend "Y";

estadd local rfe "Y";
estadd local controls "Y";
estadd scalar nobs=e(N);
estadd scalar rsq=e(r2);

eststo: xi:areg ln_output native_decentralized native i.prov_id i.year `controls' decentralized_* prov_year*, absorb(leader_id) cluster (clusterg);
estadd local pfe "Y";
estadd local yfe "Y";
estadd local ptrend "Y";
estadd local rfe "Y";
estadd local controls "Y";
estadd local controls_d "Y";

estadd scalar nobs=e(N);
estadd scalar rsq=e(r2);


esttab using draft/DeathOutput.tex, replace
	width(\hsize) 
	mlabel (, depvar)
	b(3)
	se(3)
	noconstant
	star(* 0.10 ** 0.05 *** 0.01)
	keep(
 native_decentralized
 native
		)
	label
	stats(
		pfe 
		yfe
		ptrend
		rfe
		controls
		controls_d
	 
		nobs
		rsq
		, 
		labels(
			"Province FE" 
			"Year FE"
			"Provincial trends"
			"Regulator FE"
			"Controls"
			"Decentralization * Controls"
		   
			"\# observations"
			"R-Squared"
			) 
		fmt(0 0 0 0 0 0 0 2)
		layout(@)
		)
	nonotes
	addnotes(
	)
	;





